<?php
class WorkerModel extends Orm_Base{
    public $table = 'worker';
    public $field = array(
        'id' => array('type' => "int(11) unsigned",'comment' => ''),
        'name' => array('type' => "varchar(50)",'comment' => ''),
        'photo' => array('type' => "varchar(200)",'comment' => ''),
        'sex' => array('type' => "tinyint(1)",'comment' => ''),
        'age' => array('type' => "tinyint(3)",'comment' => '年龄'),
        'birthdate' => array('type' => "int(11)",'comment' => ''),
        'phone' => array('type' => "varchar(11)",'comment' => ''),
        'critcode' => array('type' => "varchar(18)",'comment' => ''),
        'nation' => array('type' => "tinyint(2)",'comment' => '民族'),
        'religion' => array('type' => "tinyint(2)",'comment' => '宗教'),
        'healthy_status' => array('type' => "tinyint(1)",'comment' => '健康状况(1.优秀、2.良好、3.合格、4.不合格)'),
        'healthy_licence' => array('type' => "tinyint(1)",'comment' => '健康证'),
        'department' => array('type' => "tinyint(2)",'comment' => '所在部门'),
        'worker_type' => array('type' => "tinyint(1)",'comment' => '人员类别'),
        'work_licence' => array('type' => "tinyint(1)",'comment' => '上岗证'),
        'education_levels' => array('type' => "tinyint(2)",'comment' => '文化程度'),
        'married' => array('type' => "tinyint(1)",'comment' => '婚姻状况'),
        'native_place' => array('type' => "varchar(50)",'comment' => '籍贯'),
        'created' => array('type' => "int(11)",'comment' => ''),
        'updated' => array('type' => "int(11)",'comment' => ''),
        'status' => array('type' => "tinyint(1)",'comment' => '当前状态(1.正常、2.离职)'),
        'role_status' => array('type' => "tinyint(1)",'comment' => '是否分配角色(1.是、2.否)'),
        'hiredate' => array('type' => "varchar(10)",'comment' => '入职日期'),
        'resource' => array('type' => "tinyint(1)",'comment' => '招聘渠道'),
        'probation_period' => array('type' => "tinyint(10)",'comment' => '试用期'),
        'probation_fee' => array('type' => "int(10)",'comment' => '试用期薪资'),
        'fee' => array('type' => "int(10)",'comment' => '转正后薪资'),
        'old_address' => array('type' => "varchar(100)",'comment' => '暂住地址'),
        'remarks' => array('type' => "varchar(100)",'comment' => '备注'),
        'job_type' => array('type' => "tinyint(1)",'comment' => '用工性质(1.临时员工、2.正式员工)'),
        'cases' => array('type' => "varchar(20)",'comment' => '护理过病人的病例'),
        'skill' => array('type' => "varchar(20)",'comment' => '技能'),
        'disease' => array('type' => "varchar(20)",'comment' => '身体疾病'),
    );
    public $pk = 'id';
}
?>
